<?php
class admin_indexController extends My_Controllers_Admin {
	public function indexAction() {
		//		echo "hello";
	}
	public function backAction() {
		$front = Zend_Controller_Front::getInstance ();
		$front->setParam ( 'noViewRenderer', true );
		$host = "localhost";
		$user = "h183076";
		$password = "13920612255";
		$dbname = "dbh183076";
		
		mysql_connect ( $host, $user, $password );
		mysql_query ( "SET NAMES 'utf8'" ); //
		mysql_select_db ( $dbname );
		
		$mysql = "set charset utf8;\r\n"; #for mysql<=5.0 
		$q1 = mysql_query ( "show tables" );
		while ( $t = mysql_fetch_array ( $q1 ) ) {
			$table = $t [0];
			
			$q2 = mysql_query ( "show create table `$table`" );
			$sql = mysql_fetch_array ( $q2 );
			$mysql .= $sql ['Create Table'] . ";\r\n\r\n"; #DDL 
			

			$q3 = mysql_query ( "select * from `$table`" );
			while ( $data = mysql_fetch_assoc ( $q3 ) ) {
				$keys = array_keys ( $data );
				$keys = array_map ( 'addslashes', $keys );
				$keys = join ( '`,`', $keys );
				$keys = "`" . $keys . "`";
				$vals = array_values ( $data );
				$vals = array_map ( 'addslashes', $vals );
				$vals = join ( "','", $vals );
				$vals = "'" . $vals . "'";
				
				$mysql .= "insert into `$table`($keys) values($vals);\r\n";
			}
			$mysql .= "\r\n";
		
		}
		$filename = "sql/" . date ( "md" ) . ".sql" . '.gz';
		$zp = gzopen ( $filename, "w9" );
		gzwrite ( $zp, $mysql );
		gzclose ( $zp );
	}
	public function sessionAction() {
		$sess = new session ( );
		$where = $sess->getAdapter ()->quoteInto ( 'session_data = ?', '' );
		$sess->delete ( $where );
		
		$this->view->sess = $sess->fetchAll ()->toArray ();
	}
	public function messageAction() {
		echo $this->_getParam ( "message" );
	}
}
		
